insert overwrite table jms_dwd.dwd_sys_es_login_log_dt
select
     id              as   id
    ,userid          as   user_id
    ,usercode        as   user_code
    ,username        as   user_name
    ,networkid       as   network_id
    ,networkcode     as   network_code
    ,networkname     as   network_name
    ,logintype       as   login_type
    ,apptype         as   app_type
    ,logintime       as   login_time
    ,loginstatus     as   login_status
    ,ip              as   ip
    ,ipcity          as   ip_city
    ,mac             as   mac
    ,remark          as   remark
    ,createtime      as   create_time
    ,traceid         as   traceid
    ,dt              as   dt
from jms_ods.es_login_log
where dt = '{{ execution_date | cst_ds }}';